﻿using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

namespace DBManager.Company
{
    public class CompanyDAL
    {
        public static DataTable GetAllCompanyByStatus(string status)
        {
            //thong tin 
            string sql = "select * from companies where Status=" + comm.to_sqlnumber(status) + " order by status asc";
            return DBUtil.SelectTable(sql);
        }
        public static DataTable GetInfomationDAL(string companyID)
        {
            //thong tin 
            string sql = "select * from companies where companyID=" + comm.to_sqlnumber(companyID);
            return DBUtil.SelectTable(sql);
        }
    }
}
